package com.zhuiyun.pm.client.login.mapper;

import com.zhuiyun.pm.client.bid.chat.entity.Email;
import com.zhuiyun.pm.client.login.entity.ClientUser;
import com.zhuiyun.pm.config.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;



/**
 * @author syc
 * @date 2023/3/13 19:29
 */
@Mapper
public interface UserLoginDao extends BaseMapper<ClientUser> {

    /**
     * @author lyp
     * @description 通过用户id获取用户邮箱
     * @date 2023/4/2 19:39
     * @param: id
     * @return Email
     */
    @Select("<script>select user_email from client_user where id = #{id} limit 1</script>")
    String getUserEmail(Integer id);
}
